package com.red.star.wechat.data.mappers;

import com.red.star.wechat.data.core.base.MyMapper;
import com.red.star.wechat.data.entity.vo.UserRequest;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UserMapper extends MyMapper<UserRequest> {

    List<UserRequest> getUserRequestList(UserRequest userRequest);

    Long getUserRequestListCount(UserRequest userRequest);

    List<UserRequest> explorerUserRequestList(UserRequest userRequest);

    @Select("SELECT ta.id " +
            "FROM t_admin AS ta " +
            "JOIN t_admin_role AS tar ON ta.id = tar.admin_id " +
            "WHERE tar.role_id = 5")
    List<Integer> listChatAdmin();

}
